/**
 * 
 */
package com.cqcis.uip.module.salary.oper.dao;

import java.util.List;

import org.springframework.jdbc.core.support.JdbcDaoSupport;

import com.cqcis.uip.base.framework.utils.JdbcUtil;
import com.cqcis.uip.module.salary.oper.domain.ContractPayDetail;

/**
 * @author 李世军
 *
 * 创建于 2012-3-7 下午08:37:40
 */
public class ContractPayDetailDao extends JdbcDaoSupport {
	private static String FIELDS = " id ,training_contract_id,course_id,study_type,total_prices,pay_prices  ";
	private static String SELECT_SQL = " select "+FIELDS+" from customercontrol_trainingcontractpaydetail where training_contract_id=? ";
	
	/**
	 * 获取指定合同付款明细
	 * @return
	 */
    public List<ContractPayDetail> find(String trainingContractId) {
    	return JdbcUtil.queryForList(this, ContractPayDetail.class, SELECT_SQL, trainingContractId);
    }
}
